using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace shfa.snomtastic.data
{
    public partial class SqlDataProvider //: IDisposable
    {

        #region Members

        public string ConnectionString { get; set; }
        // public SqlConnection sqlCnn { get; set; }

        #endregion

        #region Constructors

        public SqlDataProvider()
        {
            this.ConnectionString = ConfigurationManager.ConnectionStrings["cnn"].ConnectionString;
        }

        #endregion

        #region Nulls

        private object GetNull(DateTime d)
        {
            if (d == null | d == DateTime.MinValue)
                return DBNull.Value;
            return d;
        }

        private object GetNull(Guid g)
        {
            if (g == null || g == Guid.Empty)
                return DBNull.Value;
            return g;
        }

        #endregion

    }
}

